Tabela PhImportDrug

Definicja tabeli PhImportDrug

Name

PhImportDrug

Code

PhImportDrug

Comment

 


Lista kolumn tabeli PhImportDrug

Name

Code

ImportDrugID

ImportDrugID

DrugNo

DrugNo

PackNo

PackNo

StItemID

StItemID

DrugID

DrugID

PackID

PackID

ImportDrugStatusID

ImportDrugStatusID

Active

Active

DrugVersion

DrugVersion


Kolumna ImportDrugID tabeli PhImportDrug

Definicja kolumny ImportDrugID tabeli PhImportDrug

Name

ImportDrugID

Code

ImportDrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrugNo tabeli PhImportDrug

Definicja kolumny DrugNo tabeli PhImportDrug

Name

DrugNo

Code

DrugNo

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna PackNo tabeli PhImportDrug

Definicja kolumny PackNo tabeli PhImportDrug

Name

PackNo

Code

PackNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StItemID tabeli PhImportDrug

Definicja kolumny StItemID tabeli PhImportDrug

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID asortymentu magazynu


Kolumna DrugID tabeli PhImportDrug

Definicja kolumny DrugID tabeli PhImportDrug

Name

DrugID

Code

DrugID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PackID tabeli PhImportDrug

Definicja kolumny PackID tabeli PhImportDrug

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ImportDrugStatusID tabeli PhImportDrug

Definicja kolumny ImportDrugStatusID tabeli PhImportDrug

Name

ImportDrugStatusID

Code

ImportDrugStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli PhImportDrug

Definicja kolumny Active tabeli PhImportDrug

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Kolumna DrugVersion tabeli PhImportDrug

Definicja kolumny DrugVersion tabeli PhImportDrug

Name

DrugVersion

Code

DrugVersion

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli PhImportDrug

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhImportDrug

Definicja klucza Identifier_1 tabeli PhImportDrug

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment